0

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.4292171001434 407 1.0731 0


No Amazon API Requests Made.


App Debug - Total Time 1.4292171001434 seconds

Number Time From Start Name Description
1 0.32753396034241 Initialise Initialise FSB Function
2 0.32867002487183 App Controller Start Start of the App controller (called before the controller of every page)
3 0.35225796699524 Start of getCategoryListByGroup Function Before first category groups query
4 0.35265207290649 After initial query Before first category groups query
5 0.35265302658081 Get Category List for Group Before the call to getCategoryList function
6 0.35265493392944 Start of GetCategoryList function Start of the function
7 0.35265588760376 Before getting categories Query to get specific category list
8 0.35311007499695 After getting categories Query to get specific category list
9 0.35311102867126 Before getting category custom Before call to function getCategoryCustom
10 0.36528205871582 After getting category custom After call to function getCategoryCustom
11 0.36528396606445 Before getting category custom Before call to function getCategoryCustom
12 0.37397909164429 After getting category custom After call to function getCategoryCustom
13 0.3739800453186 Before getting category custom Before call to function getCategoryCustom
14 0.37882709503174 After getting category custom After call to function getCategoryCustom
15 0.37882804870605 Before getting category custom Before call to function getCategoryCustom
16 0.38206505775452 After getting category custom After call to function getCategoryCustom
17 0.38206601142883 Before getting category custom Before call to function getCategoryCustom
18 0.38534188270569 After getting category custom After call to function getCategoryCustom
19 0.38534307479858 Before getting category custom Before call to function getCategoryCustom
20 0.38886594772339 After getting category custom After call to function getCategoryCustom
21 0.38886690139771 End of GetCategoryList function End of the function
22 0.38887095451355 Get Category List for Group Before the call to getCategoryList function
23 0.38887310028076 Start of GetCategoryList function Start of the function
24 0.38887405395508 Before getting categories Query to get specific category list
25 0.38923501968384 End of getCategoryListByGroup Function Before return()
26 1.1734070777893 App Controller End End of the App controller (called before the controller of every page)
27 1.3434300422668 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.3444740772247 Before Get Options Before the call to getOptions in the tpl class
29 1.3998770713806 After Get Options After the call to getOptions in the tpl class
30 1.3999049663544 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.4292089939117 Finalizing debug Before the debug is output to the page.
32 1.4292159080505 End of App This is the end of the app logging, final timestamp


Query Debug - 407 Database Queries. Total time 1.0731 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0010 0.0010430812835693
SELECT parameter, value FROM parameters
2 0.0033 0.0032830238342285
SELECT * FROM `bad_bots`
3 0.0003 0.00026798248291016
SET time_zone = 'Europe/London'
4 0.0004 0.0004429817199707
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0004 0.0004119873046875
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.195\";}'
6 0.0004 0.00035500526428223
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1751912146'
7 0.0007 0.00070595741271973
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00028681755065918
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0004 0.00037384033203125
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
10 0.0003 0.0002601146697998
SELECT * FROM pages WHERE id = 52
11 0.0011 0.0010840892791748
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0218 0.021794080734253
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0005 0.00047206878662109
SELECT * FROM pages WHERE pagename = 'search'
14 0.0004 0.00039005279541016
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00043988227844238
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0048 0.0048038959503174
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0004 0.00037813186645508
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0003 0.00028896331787109
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0003 0.0003058910369873
SELECT id FROM categories WHERE parent_id = '26'
20 0.0048 0.0048239231109619
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
21 0.0005 0.00046992301940918
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
22 0.0004 0.00039887428283691
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
23 0.0003 0.0003349781036377
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0003 0.00031399726867676
SELECT * FROM categorygroups WHERE id = '1'
25 0.0030 0.0030450820922852
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0003 0.00034785270690918
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0003 0.00030684471130371
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.00032305717468262
SELECT id FROM categories WHERE parent_id = '27'
29 0.0031 0.0031108856201172
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
30 0.0004 0.00042605400085449
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
31 0.0004 0.00043892860412598
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0003 0.00033307075500488
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.00032615661621094
SELECT * FROM categorygroups WHERE id = '1'
34 0.0011 0.0011420249938965
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0003 0.00034809112548828
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0003 0.00030517578125
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0003 0.00032711029052734
SELECT id FROM categories WHERE parent_id = '28'
38 0.0013 0.0012531280517578
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
39 0.0004 0.00040602684020996
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
40 0.0004 0.00041604042053223
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0003 0.00032401084899902
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0003 0.00030684471130371
SELECT * FROM categorygroups WHERE id = '1'
43 0.0004 0.00041890144348145
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0003 0.00032687187194824
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0003 0.00028204917907715
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00029897689819336
SELECT id FROM categories WHERE parent_id = '29'
47 0.0005 0.00051498413085938
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
48 0.0004 0.00037598609924316
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
49 0.0004 0.00037813186645508
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0003 0.00032711029052734
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.00029492378234863
SELECT * FROM categorygroups WHERE id = '1'
52 0.0004 0.0003960132598877
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0003 0.0003361701965332
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0003 0.00027990341186523
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.00033378601074219
SELECT id FROM categories WHERE parent_id = '30'
56 0.0005 0.00046586990356445
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
57 0.0003 0.00034999847412109
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
58 0.0004 0.00038409233093262
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0004 0.00035691261291504
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.00034904479980469
SELECT * FROM categorygroups WHERE id = '1'
61 0.0005 0.00045394897460938
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0004 0.00037288665771484
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0003 0.00033187866210938
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0003 0.00031590461730957
SELECT id FROM categories WHERE parent_id = '31'
65 0.0005 0.00052094459533691
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
66 0.0004 0.00036883354187012
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
67 0.0004 0.00036382675170898
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0003 0.00031590461730957
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00045108795166016
SELECT * FROM categorygroups WHERE id = '1'
70 0.0004 0.00035810470581055
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0015 0.0014591217041016
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0004 0.00043678283691406
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0004 0.00040984153747559
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74 0.0003 0.00028896331787109
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0010 0.0010089874267578
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0006 0.00061297416687012
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.7769 0.77693891525269
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.195') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.195') <= INET_ATON(ip_end)
78 0.0017 0.0016829967498779
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0007 0.00069713592529297
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0004 0.00035309791564941
SELECT * FROM pages WHERE pagename = 'search'
81 0.0047 0.004702091217041
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
82 0.0013 0.0013370513916016
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83 0.0005 0.00046801567077637
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84 0.0047 0.0046780109405518
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
85 0.0013 0.0012600421905518
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86 0.0004 0.00038695335388184
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87 0.0009 0.000885009765625
INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT 'easehold bote cafe hermetique botes et coffrets the et cafe', NOW(), '216.73.216.195'
88 0.0009 0.00087308883666992
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
89 0.0010 0.00099492073059082
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
90 0.0039 0.0039360523223877
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE 'easehold') OR (keyfeatures LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (keyfeatures LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (keyfeatures LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (keyfeatures LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (keyfeatures LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (keyfeatures LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (keyfeatures LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (keyfeatures LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (keyfeatures LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (keyfeatures LIKE 'cafe') OR (title LIKE 'cafe'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
91 0.0003 0.00034403800964355
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (title LIKE 'cafe'))
		AND hide = 0
92 0.0003 0.00032615661621094
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (title LIKE 'cafe'))
		AND hide = 0
93 0.0003 0.00032591819763184
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
94 0.0067 0.0067338943481445
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%easehold%') OR (keyfeatures LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (keyfeatures LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (keyfeatures LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (keyfeatures LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (keyfeatures LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (keyfeatures LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (keyfeatures LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (keyfeatures LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (keyfeatures LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (keyfeatures LIKE '%cafe%') OR (title LIKE '%cafe%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
95 0.0003 0.00028514862060547
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%'))
		AND hide = 0
96 0.0002 0.00024604797363281
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%'))
		AND hide = 0
97 0.0003 0.00034999847412109
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
98 0.0004 0.00035285949707031
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
99 0.0039 0.0038650035858154
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE 'easehold') OR (keyfeatures LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (keyfeatures LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (keyfeatures LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (keyfeatures LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (keyfeatures LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (keyfeatures LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (keyfeatures LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (keyfeatures LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (keyfeatures LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (keyfeatures LIKE 'cafe') OR (title LIKE 'cafe'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
100 0.0003 0.00029397010803223
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (title LIKE 'cafe'))
		AND hide = 0
101 0.0002 0.00024008750915527
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (title LIKE 'cafe'))
		AND hide = 0
102 0.0003 0.00033378601074219
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
103 0.0068 0.0067868232727051
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%easehold%') OR (keyfeatures LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (keyfeatures LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (keyfeatures LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (keyfeatures LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (keyfeatures LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (keyfeatures LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (keyfeatures LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (keyfeatures LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (keyfeatures LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (keyfeatures LIKE '%cafe%') OR (title LIKE '%cafe%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
104 0.0004 0.00036501884460449
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%'))
		AND hide = 0
105 0.0002 0.00024104118347168
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%'))
		AND hide = 0
106 0.0003 0.00029611587524414
SELECT * FROM products WHERE id = '3664'
107 0.0003 0.00033903121948242
SELECT * FROM productimages WHERE product_id = '3664' ORDER BY sortorder ASC
108 0.0005 0.00049710273742676
SELECT * FROM product_image_select WHERE product_id = '3664'
109 0.0003 0.00028705596923828
SELECT * FROM productcustomimages WHERE product_id = '3664'
110 0.0006 0.00058484077453613
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3664' AND a.name = n.originalname
111 0.0003 0.00030899047851562
SELECT * FROM productoffers WHERE product_id = '3664' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0002 0.00024700164794922
SELECT * FROM productoffers
                WHERE product_id = '3664' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0003 0.00025486946105957
SELECT * FROM productoffers
                WHERE product_id = 3664
                ORDER BY price ASC LIMIT 1
114 0.0003 0.00025582313537598
SELECT value FROM productattributes
                WHERE product_id = '3664'
                AND name = 'ListPriceAmount'
115 0.0003 0.00027704238891602
SELECT value FROM productattributes WHERE product_id = '3664' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
116 0.0003 0.00033807754516602
SELECT * FROM products WHERE id = '3748'
117 0.0003 0.00032997131347656
SELECT * FROM productimages WHERE product_id = '3748' ORDER BY sortorder ASC
118 0.0004 0.00043797492980957
SELECT * FROM product_image_select WHERE product_id = '3748'
119 0.0003 0.00025796890258789
SELECT * FROM productcustomimages WHERE product_id = '3748'
120 0.0009 0.00088596343994141
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3748' AND a.name = n.originalname
121 0.0003 0.00029087066650391
SELECT * FROM productoffers WHERE product_id = '3748' AND merchantid = 'A1X6FK5RDHNB96'
122 0.0002 0.00023603439331055
SELECT * FROM productoffers
                WHERE product_id = '3748' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0002 0.00022292137145996
SELECT * FROM productoffers
                WHERE product_id = 3748
                ORDER BY price ASC LIMIT 1
124 0.0002 0.00024700164794922
SELECT value FROM productattributes
                WHERE product_id = '3748'
                AND name = 'ListPriceAmount'
125 0.0003 0.00027894973754883
SELECT value FROM productattributes WHERE product_id = '3748' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
126 0.0004 0.00035309791564941
SELECT * FROM products WHERE id = '925'
127 0.0003 0.00030899047851562
SELECT * FROM productimages WHERE product_id = '925' ORDER BY sortorder ASC
128 0.0004 0.0004279613494873
SELECT * FROM product_image_select WHERE product_id = '925'
129 0.0003 0.00025796890258789
SELECT * FROM productcustomimages WHERE product_id = '925'
130 0.0007 0.00066518783569336
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '925' AND a.name = n.originalname
131 0.0003 0.00028800964355469
SELECT * FROM productoffers WHERE product_id = '925' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0002 0.00023579597473145
SELECT * FROM productoffers
                WHERE product_id = '925' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0002 0.00022387504577637
SELECT * FROM productoffers
                WHERE product_id = 925
                ORDER BY price ASC LIMIT 1
134 0.0002 0.00023388862609863
SELECT value FROM productattributes
                WHERE product_id = '925'
                AND name = 'ListPriceAmount'
135 0.0003 0.00025105476379395
SELECT value FROM productattributes WHERE product_id = '925' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0003 0.00032901763916016
SELECT * FROM products WHERE id = '854'
137 0.0003 0.00029110908508301
SELECT * FROM productimages WHERE product_id = '854' ORDER BY sortorder ASC
138 0.0004 0.00044798851013184
SELECT * FROM product_image_select WHERE product_id = '854'
139 0.0003 0.00026392936706543
SELECT * FROM productcustomimages WHERE product_id = '854'
140 0.0006 0.00062417984008789
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '854' AND a.name = n.originalname
141 0.0003 0.00030303001403809
SELECT * FROM productoffers WHERE product_id = '854' AND merchantid = 'A1X6FK5RDHNB96'
142 0.0003 0.00025296211242676
SELECT * FROM productoffers
                WHERE product_id = '854' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0002 0.00024604797363281
SELECT * FROM productoffers
                WHERE product_id = 854
                ORDER BY price ASC LIMIT 1
144 0.0002 0.00023198127746582
SELECT value FROM productattributes
                WHERE product_id = '854'
                AND name = 'ListPriceAmount'
145 0.0002 0.00024890899658203
SELECT value FROM productattributes WHERE product_id = '854' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
146 0.0003 0.00031590461730957
SELECT * FROM products WHERE id = '906'
147 0.0003 0.00029778480529785
SELECT * FROM productimages WHERE product_id = '906' ORDER BY sortorder ASC
148 0.0004 0.00042819976806641
SELECT * FROM product_image_select WHERE product_id = '906'
149 0.0003 0.00027108192443848
SELECT * FROM productcustomimages WHERE product_id = '906'
150 0.0009 0.00089597702026367
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '906' AND a.name = n.originalname
151 0.0003 0.00028204917907715
SELECT * FROM productoffers WHERE product_id = '906' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0002 0.00023913383483887
SELECT * FROM productoffers
                WHERE product_id = '906' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0002 0.00022792816162109
SELECT * FROM productoffers
                WHERE product_id = 906
                ORDER BY price ASC LIMIT 1
154 0.0003 0.00025177001953125
SELECT value FROM productattributes
                WHERE product_id = '906'
                AND name = 'ListPriceAmount'
155 0.0003 0.00025606155395508
SELECT value FROM productattributes WHERE product_id = '906' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0003 0.00032591819763184
SELECT * FROM products WHERE id = '1374'
157 0.0003 0.0002899169921875
SELECT * FROM productimages WHERE product_id = '1374' ORDER BY sortorder ASC
158 0.0004 0.0004420280456543
SELECT * FROM product_image_select WHERE product_id = '1374'
159 0.0003 0.00026488304138184
SELECT * FROM productcustomimages WHERE product_id = '1374'
160 0.0008 0.00083708763122559
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1374' AND a.name = n.originalname
161 0.0003 0.0002899169921875
SELECT * FROM productoffers WHERE product_id = '1374' AND merchantid = 'A1X6FK5RDHNB96'
162 0.0002 0.00023794174194336
SELECT * FROM productoffers
                WHERE product_id = '1374' AND price > 0
                ORDER BY price ASC LIMIT 1
163 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = 1374
                ORDER BY price ASC LIMIT 1
164 0.0002 0.00024318695068359
SELECT value FROM productattributes
                WHERE product_id = '1374'
                AND name = 'ListPriceAmount'
165 0.0003 0.00031805038452148
SELECT * FROM products WHERE id = '1242'
166 0.0003 0.00029492378234863
SELECT * FROM productimages WHERE product_id = '1242' ORDER BY sortorder ASC
167 0.0004 0.00042986869812012
SELECT * FROM product_image_select WHERE product_id = '1242'
168 0.0003 0.00026988983154297
SELECT * FROM productcustomimages WHERE product_id = '1242'
169 0.0007 0.00066614151000977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1242' AND a.name = n.originalname
170 0.0003 0.00029683113098145
SELECT * FROM productoffers WHERE product_id = '1242' AND merchantid = 'A1X6FK5RDHNB96'
171 0.0003 0.00026082992553711
SELECT * FROM productoffers
                WHERE product_id = '1242' AND price > 0
                ORDER BY price ASC LIMIT 1
172 0.0002 0.0002288818359375
SELECT * FROM productoffers
                WHERE product_id = 1242
                ORDER BY price ASC LIMIT 1
173 0.0003 0.00025796890258789
SELECT value FROM productattributes
                WHERE product_id = '1242'
                AND name = 'ListPriceAmount'
174 0.0003 0.00026488304138184
SELECT value FROM productattributes WHERE product_id = '1242' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
175 0.0003 0.00032210350036621
SELECT * FROM products WHERE id = '4086'
176 0.0003 0.00029397010803223
SELECT * FROM productimages WHERE product_id = '4086' ORDER BY sortorder ASC
177 0.0003 0.0003199577331543
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4086' AND p.id = pi.product_id ORDER BY pi.sortorder
178 0.0005 0.00046014785766602
SELECT * FROM product_image_select WHERE product_id = '4086'
179 0.0003 0.00029182434082031
SELECT * FROM productcustomimages WHERE product_id = '4086'
180 0.0003 0.00032615661621094
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4086'
                GROUP BY o.product_id
181 0.0004 0.00042295455932617
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4086'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
182 0.0003 0.00025701522827148
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4086
183 0.0007 0.00072908401489258
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4086' AND a.name = n.originalname
184 0.0003 0.00025200843811035
SELECT * FROM productoffers WHERE product_id = '4086' AND merchantid = 'A1X6FK5RDHNB96'
185 0.0006 0.00061392784118652
SELECT * FROM productoffers
                WHERE product_id = '4086' AND price > 0
                ORDER BY price ASC LIMIT 1
186 0.0005 0.00052404403686523
SELECT * FROM productoffers
                WHERE product_id = 4086
                ORDER BY price ASC LIMIT 1
187 0.0005 0.00053906440734863
SELECT value FROM productattributes
                WHERE product_id = '4086'
                AND name = 'ListPriceAmount'
188 0.0005 0.00051999092102051
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4086'
                GROUP BY o.product_id
189 0.0009 0.00088000297546387
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4086'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
190 0.0005 0.00052499771118164
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4086
191 0.0006 0.00060391426086426
SELECT value FROM productattributes WHERE product_id = '4086' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
192 0.0007 0.00072908401489258
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4086'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
193 0.0005 0.00045609474182129
SELECT * FROM products WHERE id = '4092'
194 0.0008 0.00080609321594238
SELECT * FROM productimages WHERE product_id = '4092' ORDER BY sortorder ASC
195 0.0014 0.0014479160308838
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4092' AND p.id = pi.product_id ORDER BY pi.sortorder
196 0.0010 0.00096297264099121
SELECT * FROM product_image_select WHERE product_id = '4092'
197 0.0005 0.00046682357788086
SELECT * FROM productcustomimages WHERE product_id = '4092'
198 0.0007 0.00072908401489258
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4092'
                GROUP BY o.product_id
199 0.0013 0.001338005065918
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4092'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
200 0.0006 0.00060486793518066
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4092
201 0.0017 0.0017340183258057
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4092' AND a.name = n.originalname
202 0.0004 0.00043296813964844
SELECT * FROM productoffers WHERE product_id = '4092' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0004 0.00039100646972656
SELECT * FROM productoffers
                WHERE product_id = '4092' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0004 0.00038290023803711
SELECT * FROM productoffers
                WHERE product_id = 4092
                ORDER BY price ASC LIMIT 1
205 0.0005 0.00047016143798828
SELECT value FROM productattributes
                WHERE product_id = '4092'
                AND name = 'ListPriceAmount'
206 0.0006 0.0006260871887207
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4092'
                GROUP BY o.product_id
207 0.0013 0.001291036605835
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4092'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
208 0.0005 0.00053501129150391
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4092
209 0.0006 0.0006260871887207
SELECT value FROM productattributes WHERE product_id = '4092' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210 0.0010 0.00097012519836426
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4092'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
211 0.0008 0.00081682205200195
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4092'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
212 0.0004 0.00040698051452637
SELECT * FROM products WHERE id = '996'
213 0.0005 0.00054192543029785
SELECT * FROM productimages WHERE product_id = '996' ORDER BY sortorder ASC
214 0.0010 0.00099086761474609
SELECT * FROM product_image_select WHERE product_id = '996'
215 0.0005 0.00048685073852539
SELECT * FROM productcustomimages WHERE product_id = '996'
216 0.0015 0.0014798641204834
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '996' AND a.name = n.originalname
217 0.0005 0.00052690505981445
SELECT * FROM productoffers WHERE product_id = '996' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0005 0.00046396255493164
SELECT * FROM productoffers
                WHERE product_id = '996' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0004 0.00040602684020996
SELECT * FROM productoffers
                WHERE product_id = 996
                ORDER BY price ASC LIMIT 1
220 0.0004 0.00043511390686035
SELECT value FROM productattributes
                WHERE product_id = '996'
                AND name = 'ListPriceAmount'
221 0.0006 0.00062108039855957
SELECT * FROM products WHERE id = '3628'
222 0.0005 0.00052189826965332
SELECT * FROM productimages WHERE product_id = '3628' ORDER BY sortorder ASC
223 0.0005 0.00053787231445312
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3628' AND p.id = pi.product_id ORDER BY pi.sortorder
224 0.0011 0.0010819435119629
SELECT * FROM product_image_select WHERE product_id = '3628'
225 0.0005 0.00046181678771973
SELECT * FROM productcustomimages WHERE product_id = '3628'
226 0.0008 0.00075006484985352
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3628'
                GROUP BY o.product_id
227 0.0008 0.00076699256896973
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3628'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
228 0.0004 0.00042390823364258
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3628
229 0.0013 0.00130295753479
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3628' AND a.name = n.originalname
230 0.0004 0.00040888786315918
SELECT * FROM productoffers WHERE product_id = '3628' AND merchantid = 'A1X6FK5RDHNB96'
231 0.0004 0.00040912628173828
SELECT * FROM productoffers
                WHERE product_id = '3628' AND price > 0
                ORDER BY price ASC LIMIT 1
232 0.0004 0.00035309791564941
SELECT * FROM productoffers
                WHERE product_id = 3628
                ORDER BY price ASC LIMIT 1
233 0.0004 0.0003819465637207
SELECT value FROM productattributes
                WHERE product_id = '3628'
                AND name = 'ListPriceAmount'
234 0.0005 0.00048184394836426
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3628'
                GROUP BY o.product_id
235 0.0008 0.00075292587280273
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3628'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
236 0.0004 0.00042915344238281
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3628
237 0.0006 0.00058102607727051
SELECT value FROM productattributes WHERE product_id = '3628' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238 0.0008 0.00077295303344727
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3628'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
239 0.0007 0.00067305564880371
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3628'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
240 0.0004 0.00042581558227539
SELECT * FROM products WHERE parent_id = '3628'
241 0.0006 0.00058412551879883
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3629' AND a.name = n.originalname
242 0.0004 0.00043892860412598
SELECT * FROM productoffers WHERE product_id = '3629' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0004 0.0003969669342041
SELECT * FROM productoffers
                WHERE product_id = '3629' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0003 0.00031495094299316
SELECT * FROM productoffers
                WHERE product_id = 3629
                ORDER BY price ASC LIMIT 1
245 0.0003 0.00032997131347656
SELECT value FROM productattributes
                WHERE product_id = '3629'
                AND name = 'ListPriceAmount'
246 0.0003 0.00033402442932129
SELECT * FROM products WHERE id = '3625'
247 0.0005 0.00048089027404785
SELECT * FROM productimages WHERE product_id = '3625' ORDER BY sortorder ASC
248 0.0008 0.0007779598236084
SELECT * FROM product_image_select WHERE product_id = '3625'
249 0.0004 0.00038480758666992
SELECT * FROM productcustomimages WHERE product_id = '3625'
250 0.0013 0.0013229846954346
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3625' AND a.name = n.originalname
251 0.0004 0.00043082237243652
SELECT * FROM productoffers WHERE product_id = '3625' AND merchantid = 'A1X6FK5RDHNB96'
252 0.0004 0.0003509521484375
SELECT * FROM productoffers
                WHERE product_id = '3625' AND price > 0
                ORDER BY price ASC LIMIT 1
253 0.0003 0.00032901763916016
SELECT * FROM productoffers
                WHERE product_id = 3625
                ORDER BY price ASC LIMIT 1
254 0.0004 0.00035214424133301
SELECT value FROM productattributes
                WHERE product_id = '3625'
                AND name = 'ListPriceAmount'
255 0.0004 0.00043797492980957
SELECT value FROM productattributes WHERE product_id = '3625' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256 0.0005 0.00048613548278809
SELECT * FROM products WHERE id = '2537'
257 0.0004 0.00043702125549316
SELECT * FROM productimages WHERE product_id = '2537' ORDER BY sortorder ASC
258 0.0004 0.00036883354187012
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2537' AND p.id = pi.product_id ORDER BY pi.sortorder
259 0.0008 0.00077390670776367
SELECT * FROM product_image_select WHERE product_id = '2537'
260 0.0004 0.00040197372436523
SELECT * FROM productcustomimages WHERE product_id = '2537'
261 0.0005 0.00046586990356445
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2537'
                GROUP BY o.product_id
262 0.0006 0.00058388710021973
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2537'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
263 0.0004 0.00038313865661621
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2537
264 0.0008 0.00077104568481445
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2537' AND a.name = n.originalname
265 0.0002 0.00024700164794922
SELECT * FROM productoffers WHERE product_id = '2537' AND merchantid = 'A1X6FK5RDHNB96'
266 0.0003 0.00025010108947754
SELECT * FROM productoffers
                WHERE product_id = '2537' AND price > 0
                ORDER BY price ASC LIMIT 1
267 0.0002 0.00023198127746582
SELECT * FROM productoffers
                WHERE product_id = 2537
                ORDER BY price ASC LIMIT 1
268 0.0002 0.00023794174194336
SELECT value FROM productattributes
                WHERE product_id = '2537'
                AND name = 'ListPriceAmount'
269 0.0003 0.00028395652770996
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2537'
                GROUP BY o.product_id
270 0.0004 0.00039196014404297
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2537'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
271 0.0003 0.00025582313537598
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2537
272 0.0003 0.00030779838562012
SELECT value FROM productattributes WHERE product_id = '2537' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
273 0.0003 0.00027203559875488
SELECT * FROM products WHERE parent_id = '2537'
274 0.0006 0.0005800724029541
SELECT * FROM products WHERE id = '872'
275 0.0020 0.0020251274108887
SELECT * FROM productimages WHERE product_id = '872' ORDER BY sortorder ASC
276 0.0053 0.0053200721740723
SELECT * FROM product_image_select WHERE product_id = '872'
277 0.0024 0.0023989677429199
SELECT * FROM productcustomimages WHERE product_id = '872'
278 0.0016 0.0015740394592285
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '872' AND a.name = n.originalname
279 0.0006 0.000579833984375
SELECT * FROM productoffers WHERE product_id = '872' AND merchantid = 'A1X6FK5RDHNB96'
280 0.0005 0.00045585632324219
SELECT * FROM productoffers
                WHERE product_id = '872' AND price > 0
                ORDER BY price ASC LIMIT 1
281 0.0004 0.00038719177246094
SELECT * FROM productoffers
                WHERE product_id = 872
                ORDER BY price ASC LIMIT 1
282 0.0005 0.00045990943908691
SELECT value FROM productattributes
                WHERE product_id = '872'
                AND name = 'ListPriceAmount'
283 0.0006 0.00060701370239258
SELECT * FROM products WHERE id = '3008'
284 0.0006 0.00063991546630859
SELECT * FROM productimages WHERE product_id = '3008' ORDER BY sortorder ASC
285 0.0009 0.000946044921875
SELECT * FROM product_image_select WHERE product_id = '3008'
286 0.0005 0.00046610832214355
SELECT * FROM productcustomimages WHERE product_id = '3008'
287 0.0014 0.0014290809631348
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3008' AND a.name = n.originalname
288 0.0006 0.0005800724029541
SELECT * FROM productoffers WHERE product_id = '3008' AND merchantid = 'A1X6FK5RDHNB96'
289 0.0004 0.00040197372436523
SELECT * FROM productoffers
                WHERE product_id = '3008' AND price > 0
                ORDER BY price ASC LIMIT 1
290 0.0004 0.00035619735717773
SELECT * FROM productoffers
                WHERE product_id = 3008
                ORDER BY price ASC LIMIT 1
291 0.0004 0.00039100646972656
SELECT value FROM productattributes
                WHERE product_id = '3008'
                AND name = 'ListPriceAmount'
292 0.0004 0.00042200088500977
SELECT value FROM productattributes WHERE product_id = '3008' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
293 0.0006 0.00058317184448242
SELECT * FROM products WHERE id = '1226'
294 0.0005 0.0005180835723877
SELECT * FROM productimages WHERE product_id = '1226' ORDER BY sortorder ASC
295 0.0009 0.00094509124755859
SELECT * FROM product_image_select WHERE product_id = '1226'
296 0.0005 0.00046610832214355
SELECT * FROM productcustomimages WHERE product_id = '1226'
297 0.0017 0.0017061233520508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1226' AND a.name = n.originalname
298 0.0005 0.00050091743469238
SELECT * FROM productoffers WHERE product_id = '1226' AND merchantid = 'A1X6FK5RDHNB96'
299 0.0004 0.00039291381835938
SELECT * FROM productoffers
                WHERE product_id = '1226' AND price > 0
                ORDER BY price ASC LIMIT 1
300 0.0003 0.00034618377685547
SELECT * FROM productoffers
                WHERE product_id = 1226
                ORDER BY price ASC LIMIT 1
301 0.0004 0.00037789344787598
SELECT value FROM productattributes
                WHERE product_id = '1226'
                AND name = 'ListPriceAmount'
302 0.0004 0.00042200088500977
SELECT value FROM productattributes WHERE product_id = '1226' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
303 0.0006 0.00059008598327637
SELECT * FROM products WHERE id = '1051'
304 0.0006 0.00056195259094238
SELECT * FROM productimages WHERE product_id = '1051' ORDER BY sortorder ASC
305 0.0009 0.00093793869018555
SELECT * FROM product_image_select WHERE product_id = '1051'
306 0.0005 0.00046896934509277
SELECT * FROM productcustomimages WHERE product_id = '1051'
307 0.0012 0.0011501312255859
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1051' AND a.name = n.originalname
308 0.0005 0.00053715705871582
SELECT * FROM productoffers WHERE product_id = '1051' AND merchantid = 'A1X6FK5RDHNB96'
309 0.0004 0.00040292739868164
SELECT * FROM productoffers
                WHERE product_id = '1051' AND price > 0
                ORDER BY price ASC LIMIT 1
310 0.0004 0.00036501884460449
SELECT * FROM productoffers
                WHERE product_id = 1051
                ORDER BY price ASC LIMIT 1
311 0.0004 0.00040102005004883
SELECT value FROM productattributes
                WHERE product_id = '1051'
                AND name = 'ListPriceAmount'
312 0.0005 0.00048398971557617
SELECT value FROM productattributes WHERE product_id = '1051' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
313 0.0006 0.00059604644775391
SELECT * FROM products WHERE id = '775'
314 0.0005 0.00053095817565918
SELECT * FROM productimages WHERE product_id = '775' ORDER BY sortorder ASC
315 0.0009 0.00089406967163086
SELECT * FROM product_image_select WHERE product_id = '775'
316 0.0005 0.00048208236694336
SELECT * FROM productcustomimages WHERE product_id = '775'
317 0.0012 0.0012011528015137
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '775' AND a.name = n.originalname
318 0.0005 0.00051021575927734
SELECT * FROM productoffers WHERE product_id = '775' AND merchantid = 'A1X6FK5RDHNB96'
319 0.0004 0.00038886070251465
SELECT * FROM productoffers
                WHERE product_id = '775' AND price > 0
                ORDER BY price ASC LIMIT 1
320 0.0004 0.00042319297790527
SELECT * FROM productoffers
                WHERE product_id = 775
                ORDER BY price ASC LIMIT 1
321 0.0004 0.00040602684020996
SELECT value FROM productattributes
                WHERE product_id = '775'
                AND name = 'ListPriceAmount'
322 0.0004 0.00042390823364258
SELECT value FROM productattributes WHERE product_id = '775' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
323 0.0018 0.0018360614776611
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3664' ORDER BY timestamp DESC
324 0.0004 0.00036907196044922
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3748' ORDER BY timestamp DESC
325 0.0003 0.00033402442932129
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '925' ORDER BY timestamp DESC
326 0.0003 0.00031399726867676
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '854' ORDER BY timestamp DESC
327 0.0003 0.00029897689819336
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '906' ORDER BY timestamp DESC
328 0.0003 0.00029993057250977
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1374' ORDER BY timestamp DESC
329 0.0003 0.00030684471130371
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1242' ORDER BY timestamp DESC
330 0.0003 0.00029110908508301
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4086' ORDER BY timestamp DESC
331 0.0003 0.00034904479980469
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4092' ORDER BY timestamp DESC
332 0.0003 0.00029897689819336
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '996' ORDER BY timestamp DESC
333 0.0003 0.00029706954956055
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3628' ORDER BY timestamp DESC
334 0.0003 0.00028395652770996
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3625' ORDER BY timestamp DESC
335 0.0003 0.00029897689819336
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2537' ORDER BY timestamp DESC
336 0.0003 0.00030899047851562
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '872' ORDER BY timestamp DESC
337 0.0004 0.00038313865661621
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3008' ORDER BY timestamp DESC
338 0.0003 0.00033211708068848
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1226' ORDER BY timestamp DESC
339 0.0003 0.00030899047851562
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1051' ORDER BY timestamp DESC
340 0.0003 0.00029897689819336
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '775' ORDER BY timestamp DESC
341 0.0006 0.00061798095703125
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
342 0.0005 0.00053811073303223
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
343 0.0005 0.00046896934509277
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
344 0.0259 0.025943994522095
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
345 0.0008 0.00075387954711914
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
346 0.0006 0.00057005882263184
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
347 0.0005 0.00051403045654297
SELECT * FROM products WHERE id = 1626
348 0.0004 0.0003960132598877
SELECT * FROM products WHERE id = 4041
349 0.0003 0.00033116340637207
SELECT * FROM products WHERE id = 4312
350 0.0003 0.00032687187194824
SELECT * FROM products WHERE id = 777
351 0.0003 0.0003359317779541
SELECT * FROM products WHERE id = 3881
352 0.0003 0.00032901763916016
SELECT * FROM products WHERE id = 4213
353 0.0003 0.0003359317779541
SELECT * FROM products WHERE id = '1626'
354 0.0005 0.00047206878662109
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
355 0.0008 0.00076794624328613
SELECT * FROM product_image_select WHERE product_id = '1626'
356 0.0008 0.00076603889465332
SELECT * FROM productcustomimages WHERE product_id = '1626'
357 0.0011 0.0010819435119629
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
358 0.0005 0.00047397613525391
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
359 0.0004 0.00037598609924316
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
360 0.0004 0.00041389465332031
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
361 0.0005 0.00052118301391602
SELECT * FROM products WHERE id = '4041'
362 0.0005 0.00046491622924805
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
363 0.0007 0.00073719024658203
SELECT * FROM product_image_select WHERE product_id = '4041'
364 0.0004 0.00037598609924316
SELECT * FROM productcustomimages WHERE product_id = '4041'
365 0.0012 0.0012190341949463
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
366 0.0004 0.00043892860412598
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
367 0.0004 0.00036287307739258
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
368 0.0004 0.00043606758117676
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
369 0.0005 0.00048208236694336
SELECT * FROM products WHERE id = '4312'
370 0.0004 0.00044584274291992
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
371 0.0007 0.00073909759521484
SELECT * FROM product_image_select WHERE product_id = '4312'
372 0.0004 0.00039315223693848
SELECT * FROM productcustomimages WHERE product_id = '4312'
373 0.0007 0.00071096420288086
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
374 0.0003 0.00029397010803223
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
375 0.0003 0.00026202201843262
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
376 0.0003 0.00027799606323242
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
377 0.0003 0.00032305717468262
SELECT * FROM products WHERE id = '777'
378 0.0003 0.00030708312988281
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
379 0.0004 0.00043201446533203
SELECT * FROM product_image_select WHERE product_id = '777'
380 0.0003 0.00027084350585938
SELECT * FROM productcustomimages WHERE product_id = '777'
381 0.0006 0.00064396858215332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
382 0.0003 0.00029993057250977
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
383 0.0003 0.00026297569274902
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
384 0.0003 0.00026893615722656
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
385 0.0003 0.00033402442932129
SELECT * FROM products WHERE id = '3881'
386 0.0003 0.00034618377685547
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
387 0.0004 0.00043702125549316
SELECT * FROM product_image_select WHERE product_id = '3881'
388 0.0003 0.00026416778564453
SELECT * FROM productcustomimages WHERE product_id = '3881'
389 0.0006 0.00064897537231445
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
390 0.0003 0.00034093856811523
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
391 0.0003 0.00026702880859375
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
392 0.0003 0.00027203559875488
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
393 0.0003 0.00034999847412109
SELECT * FROM products WHERE id = '4213'
394 0.0004 0.00035691261291504
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
395 0.0004 0.00043797492980957
SELECT * FROM product_image_select WHERE product_id = '4213'
396 0.0003 0.00026512145996094
SELECT * FROM productcustomimages WHERE product_id = '4213'
397 0.0007 0.00066685676574707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
398 0.0003 0.00029611587524414
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
399 0.0003 0.00026392936706543
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
400 0.0003 0.00028395652770996
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
401 0.0005 0.0005497932434082
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
402 0.0005 0.00051093101501465
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
403 0.0012 0.0011529922485352
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
404 0.0005 0.00046801567077637
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
405 0.0004 0.00037717819213867
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
406 0.0005 0.0004727840423584
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
407 0.0004 0.00040102005004883
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'